import pymysql
a=pymysql.connect(host="",
user="",
password="",database="",port=3306)
cursor = a.cursor()
with a:
    with a.cursor() as cursor:
        cursor.execute("SHOW COLUMNS FROM ev_shop_lottery")
        data=cursor.fetchall()
        for x in data:
            name=x[0]
            type=x[1]
            if type.startswith('int') or type.startswith('tinyint'):
                type='int'
            else:
                type='string'
            print(f" * @property {type} ${name}")